INSERT INTO Invoice_GDN
                      (Inv_GDNDate, Inv_GDNVNo, SessionID, Remarks, ReadOnly, LoginID, HostName, EntryDateTime, ModifyID, ModifyHostName, ModifyDateTime, BLID, BLNo, 
                      SumQTY)
SELECT     BLDate, Inv_BankVNo, SessionID, Remarks, ReadOnly, LoginID, HostName, EntryDateTime, ModifyID, ModifyHostName, ModifyDateTime, Inv_BankID, BLNo, 
                      SumQTY
FROM         Invoice_Bank

--------------------------------------------------------------------------------------------------

UPDATE    Invoice_GDN SET   Inv_GDNVNo = 'GDN-' + RIGHT(Inv_GDNVNo, LEN(Inv_GDNVNo) - 3)

--------------------------------------------------------------------------------------------------

INSERT INTO Invoice_GDNitem
                      (Inv_GDNID, Dis_Date, PartyID, ItemID, VarietyID, Qty, Type, ContainerNo, DRemarks)
SELECT     Invoice_BankItem.inv_BankID - 5 AS inv_BankID, Invoice_Bank.BLDate, Invoice_Bank.ConsigneeID, Invoice_BankItem.ItemID, Invoice_BankItem.VarietyID, 
                      Invoice_BankItem.LQTY, Invoice_BankItem.Type, Invoice_BankItem.ContainerNo, Invoice_Bank.Remarks
FROM         Invoice_BankItem INNER JOIN
                      Invoice_Bank ON Invoice_BankItem.inv_BankID = Invoice_Bank.Inv_BankID